package com.ldu.exam.dao;

import java.io.Serializable;
import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import com.ldu.exam.model.SubmitQuestion;

public interface SubmitQuestionRepository extends JpaRepository<SubmitQuestion, Serializable>
{
	
	@Query(value="SELECT submit_paper_id from t_submitpaper_questions a where a.questions_id =?1",nativeQuery=true)
	public Object findPaper(String id);
	
	@Query(value="SELECT account_id from t_submitpaper a group by a.account_id",nativeQuery=true)
	public List<String> findAllAccount();
	
}
